<?php session_start();
require_once("connect.php");
	$cekin=$_SESSION['cekin'];
	$cekout=$_SESSION['cekout'];
	$qty_org=$_SESSION['qty_org'];
	$qty_room=$_SESSION['qty_room'];
	$qty_night=$_SESSION['qty_night'];
	$id_hotel=$_SESSION['id_hotel'];
	$id_jenis=$_GET['id'];
	$username=$_POST['username'];
	$password=$_POST['password'];
	
	$sql="insert into transaksi values(NULL,'$username','$tgl')";
	$sql2 = "select * from transaksi order by no_transaksi desc limit 0,$qty_room";	
	$exe = mysql_query($sql);
	$exe2 = mysql_query($sql2);
	
	while($list=mysql_fetch_array($exe2)){
		$q = "insert into booking values (NULL,'$id_hotel','$list[0]',$list[JUMLAH])";
	$ex=mysql_query($q);
	}

?>